This model dimension represents the Financial companies. In the Group Consolidation model it represnts the master company only. The dimensionis based on the IFS Cloud dimension DIM_COMPANY. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
Company | Built as CODE + ' - ' + NAME + ' (' + CURRENCY_CODE + ')' |
Company Code | Represents the CODE of the dimension (company) |
Company Code Name | Name of the company built as CODE + ' - ' + NAME |
Company Country Code | Represents the COUNTRY code of the company |
Company Currency | Represents the CURRENCY_CODE of the company |
Company Name | Represents the NAME of the company |
Model Name |
Group Consolidation |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
COMPANY | DIM_COMPANY_GC_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |